package com.ruoyi.hr.mapper;

import com.ruoyi.hr.domain.JUser;
import com.ruoyi.hr.domain.salaryCalculation.AttendDatas;
import com.ruoyi.hr.domain.salaryCalculation.SkypayGroups;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface EmpSalaryCalculationMapper {
    List<SkypayGroups> findSkypayGroups(String urid);

    List<Map> findEmpSalaryInfoList(Map<String,Object> map);

    String getJSID(String JSID);

    List<String> findObjType(String pgid);

    List<String> findObjTypeAll(String pgid);

    Map<String,Object> findNewTerm(String pgid);

    Map<String,Object> findNewTermAll(String pgid);

    String Initialization(@Param("sql") String sql);

    List<String> findKQ();

    List<String> findYJYK(String pgid);

    List<JUser> findWorking(String jsid);

    List<String> findObjsId(@Param("objProList") List<String> objProList);

    String findWorkID(String badge);

    int deleteAttend(@Param("term") String term,@Param("jsid") String jsid);

    int deleteADJUST(@Param("term") String term,@Param("jsid") String jsid);

    int insertAttend(AttendDatas attendDatas);

    int insertADJUST(AttendDatas attendDatas);

    String findStartDate(String jsid);

    String findEndDate(String jsid);

    int insertObjsWorking(@Param("StartDate") String StartDate,@Param("endDate") String endDate,@Param("attendDatas") List<AttendDatas> attendDatas);

    int updateStartDate(@Param("term") String term,@Param("attendDatas") List<AttendDatas> attendDatas);

    int deleteStdsWorking(String jsid);

    int insertStdsWorking(@Param("jsid") String jsid,@Param("pgid") String pgid);

    void skyPayGroupSubmitBefore(String pgid);

    void skyPayGroupSubmitpgid(@Param("sql") String sql);

    void skyPayGroupSubmit(@Param("sql") String sql);

    void skyPayGroupFreeze(@Param("sql") String sql);

    void skyPayGroupCancel(@Param("sql") String sql);

    void skyPayGroupClose(@Param("sql") String sql);

    String executeProcedure(@Param("sql") String sql);


    List<Map<String,Object>> findEmpByPgid(String pgid);

    String findPeidByBadge(String badge);

    String findObjIdByTitle(String title);

    Map<String,Object> refreshButton(String pgid);

}
